const db = require('../db')

module.exports = db.defineModel('sc_jinihuo', {
	_id: db.STRING(),
	date: db.STRING(),
	
	addTime: db.STRING(),
	name: {
		type: db.STRING(),
		allowNull: true,
		defaultValue: '', 
		comment: '货品名称'
	},
	image: {
		type: db.STRING(),
		allowNull: true,
		defaultValue: '', 
		comment: '订单照片'
	},
	num1: {
		type: db.INTEGER(),
		allowNull: true,
		defaultValue: 0, 
		comment: '应收数量'
	},
	num2: {
		type: db.INTEGER(),
		allowNull: true,
		defaultValue: 0, 
		comment: '实收数量'
	},
	money1: {
		type: db.INTEGER(),
		allowNull: true,
		defaultValue: 0, 
		comment: '订单金额'
	},
	money2: {
		type: db.INTEGER(),
		allowNull: true,
		defaultValue: 0, 
		comment: '运费'
	},
	beizhu: {
		type: db.STRING(),
		allowNull: true,
		defaultValue: '', 
		comment: '备注'
	}
})
